 CREATE  INDEX [IDX_NAME] ON [dbo].[TIGER_01]([FEDIRP], [FENAME], [FETYPE], [FEDIRS])
GO
 CREATE  INDEX [IDX_ZIP] ON [dbo].[TIGER_01]([ZIPL], [ZIPR])
GO
 CREATE  INDEX [IDX_TOLAT] ON [dbo].[TIGER_01]([TOLAT]) 
GO
 CREATE  INDEX [IDX_FRLAT] ON [dbo].[TIGER_01]([FRLAT]) 
GO
 CREATE  INDEX [IDX_FRLONG] ON [dbo].[TIGER_01]([FRLONG])
GO
 CREATE  INDEX [IDX_T2_TLID] ON [dbo].[TIGER_02]([TLID]) 
GO
CREATE  INDEX [IX_FIPS55] ON [dbo].[FIPS55]([STATE_ALPHA], [PLACE_NAME])
GO
